{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Date_Range","Practices","SLOTCOUNT"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Date_Range","index":0,"n_rows":56,"n_cols":10,"rows_kept":56,"cut":false,"hidden":false,"merged":[[27,1,30,8],[43,1,44,15],[1,9,1,15],[2,9,3,15],[12,9,14,15],[2,4,2,5],[2,1,2,2],[3,1,3,2],[8,1,8,8],[7,1,7,8],[10,1,12,8]]}
[]
[null,"Vision 360 Appointment Wizard",null,null,null,null,null,null,null,"Search Criteria"]
[null,"Including Practice Details",null,null,null,null,null,null,null,"This will import all appointment data within the date range set and include practice details if added to Practices sheet"]
[null,"Enter Appointment Date Range"]
[null,"FROM","TO",null,"Count"]
[null,"2019-11-01","2019-11-30",null,"All",null,null,null,null,"Count will import the type of appointment as follows:"]
[null,null,null,null,null,null,null,null,null,"Count 1 = only actual appointments"]
[null,"Note that the 1st column called \"APPT_ID\" is linked to the actual slot time reference",null,null,null,null,null,null,null,"Count 0 = only free slots"]
[null,"which can be cross referenced when running the Cancellation Appointment Wizard",null,null,null,null,null,null,null,"Count -1 = only unavailable slots"]
[null,null,null,null,null,null,null,null,null,"Select ALL to include all the above."]
[null,"This report includes patient identifiable data! Please be careful with this data especially if taken or sent outside the practice. Please refer to your practice privacy officer or Caldicott guardian for instructions"]
[]
[]
[]
[null,"NOTE:"]
[null,"This will only work if Vision is on DLM485 or above."]
[null,"Excel 2010 - Please \"Enable Content\" if a security Warning is displayed"]
[]
[null,"Excel 2007 - Please enable both Macros... and Data Connections"]
[null,"Excel 2003 - If macros are disabled you will need to enable them via Tools menu > Macro > Security"]
[null,null,"On the Security Level tab > Select Medium. Then select the Trusted Publishers tab and tick \"Trust access to Visual Basic Project\""]
[null,null,"Click OK to close the Security window > Close Excel > Reopen this workbook and select \"Enable Macros\""]
[]
[null,"Last Updated: 18/12/2019 - Version 1.8"]
[null,"Written by: Bradley Sieve"]
[]
[null,"Disclaimer"]
[null,"In using this Microsoft Excel report you hereby acknowledge that the software cannot be guaranteed error free and may also be subject to how data is being recorded by your practice, and further acknowledge that the existence of any such errors shall not make Vision responsible for any actions you carry out based on these results."]
[]
[]
[]
[]
[null,"Version History"]
[null,"v1.8"]
[null,"Error in Book Owner ID column duplicating the initial Book Owner ID name. Error corrected in formula"]
[]
[null,"v1.7.1"]
[null,"Fix made to code after adding new column with regards to merging practice details"]
[null,"v1.7"]
[null,"New column added that shows the \"Allocated slot duration\" assigned at setup, as the expected duration can be changed by users when booking an appointment"]
[null,"and expected duration is not displayed with free slots"]
[null,"It now automatically removes blank slots, events and session header information from the Appt_data sheet, to help with calculating time"]
[null,"v1.6"]
[null,"Updated code to accommodate Scottish practice ID's that are purely numbers, as Excel was interpreting the comma separated Practice ID and Patient ID as a single number when splitting the information into separate columns"]
[]
[null,"v1.5"]
[null,"Amend code to accommodate special appointments when separating practice details"]
[null,"Enter the word \"Special\" in Pat_ID to show that it is a special appointment"]
[null,"v1.4"]
[null,"Formula change for Book Owner as the asterisk could select other owners "]
[null,"with similar characters in the name"]
[null,"Read only removed so that practice details may be saved"]
[null,"v1.3"]
[null,"The code now accepts direct appointment making, rather than it just coming from V360"]
[null,"If entered directly the comments will be ignored"]
[null,"Only if it contains the wording \"***DO NOT EDIT (V360,\" will it be separated"]

{"sheet":"Practices","index":1,"n_rows":1,"n_cols":4,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["NACSCode","Practice Name","Senior Partner","Locality"]

{"sheet":"SLOTCOUNT","index":2,"n_rows":4,"n_cols":1,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
[0]
[1]
[-1]
["All"]